At 20:37 +0300 on 10/7/98, Jackson, DeJuan wrote:
> >
> But let's not forget one of the wonders of PostgreSQL. In this world
> you can have your cake and eat it to. So, create all 4 indices and let
> the optimizer sort em out for your queries.
Yes, but whenever you update or insert a row, it's that much slower. One
should always remember not to go wild with indexing - they carry a penalty
on INSERT and UPDATE.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma